package guoanmaker.operator.business.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;


import guoanmaker.operator.business.model.OperatorHotServerPc;

public interface OperatorHotServerPcRepository extends JpaRepository<OperatorHotServerPc, String>, JpaSpecificationExecutor<OperatorHotServerPc>{
	  @Query("select u from OperatorHotServerPc u  where u.cityId=:cityId")
	    public List<OperatorHotServerPc> findBycityCode(@Param("cityId") String cityId);
	    
		@Query("select u from OperatorHotServerPc u  where u.serverId=:serverId")
	 public OperatorHotServerPc findByserverId(@Param("serverId") String serverId);
		
		  @Query("select u.serverId,u.iconPath from OperatorHotServerPc u  where u.cityId=:cityId")
		    public List<OperatorHotServerPc> findBycityCodedeleId(@Param("cityId") String cityId);
}
